﻿CREATE VIEW [dbo].[ASMS_V_SettlementBillPayItem]
	AS 
SELECT SBPI.*,
	[PI].Name as PayItemName
FROM ASMS_SettlementBillPayItem as SBPI
	left join ASMS_PayItem as [PI] on [PI].Id = SBPI.PayItemId